Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
CarrierAccountNumber (PK) | The account number assigned to the retailer by the Carrier for invoicing and delivery service ordering purposes. | ID_CRR_ACNT | Identity | integer | |
CarrierID (FK) | A unique system assigned identifier for the Carrier. | ID_CRR | Identity | integer | Carrier(PA_CRR) |
EffectiveDate | Date and time a CarrierAccount is active for tansportation management and tracking purposes. | DC_EF_DT | EffectiveDate | date | |
ExpirationDate | Date and time a CarrierAccount is no longer active for tansportation management and tracking purposes. | DC_EP_DT | ExpirationDate | datetime | |
PartyContactMethodID (FK) | A token identifier for a PartyContactMethod entity type instance. | ID_PRTY_CNCT_MTH | Identity | integer | PartyContactMethod(CO_MTH_CNCT_PTY) |